﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_StaffSearch]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_StaffSearch];
GO
CREATE PROCEDURE [dbo].[sproc_StaffSearch]
	@sql nvarchar(2048)
/*--------------------------------------
功能：查询人员
参数：
    @Name    人员姓名
    @Mobile    手机号码
    @Email    email
    @Gender    性别
    @PositionID    职位id
    @SearchBound    查询范围
---------------------------------------*/
AS
BEGIN
SET NOCOUNT ON

exec (@sql);

END
GO